CSV File Format
The CSV file format is a set of properties separated by commas. When double-quotes are used in a property value, you need to add an extra double-quote, for example, Cooling Tank CT101-B. When commas are used in a property value, you must surround the entire description with double-quotes, for example, "Pumps, Area 5."
The first line of the CSV file contains a list of the property names in the order in which they appear below it in the file. The item set property names can be listed in any order and even omitted if you want to allow the default value. The available item set property names that may be specified in the CSV file header are Name, Description, Color, Display, Priority, Expression.
At a minimum, you must at least specify the name of the item set to generate a set of item sets.
Property | Description |
---|---|
Name | The name of the item set. |
Description | The description of the item set. |
Color | A color index value (0-255) which corresponds to the color picker grid values. An RGB value in the format RGB:rrr:ggg:bbb where:
If not specified, the default color is 0. |
Display | A flag (ON|OFF) to set whether the elements in the item set are to be displayed or hidden. If not specified, the default is ON (displayed). |
Priority | Relative priority to resolve visualization for item sets containing the same elements. A priority value of 1 is the highest priority and is the default if none is specified. For best performance, it is recommended that you simply order the item sets in the CSV file in descending order of priority and not specify a priority. |
Expression | The expression field is used to specify either a simple selection expression (as outlined below) or the full path and filename of a saved item set search. Use the Item Set Search dialog to setup a selection expression and then save it to a *.ecquery.xml file. If you specify a simple selection expression, you must use this syntax: SELECT class_name WHERE property_name operator property_value logical …
|